package com.example.demo.mapper;

import com.example.demo.admin.dto.SearchDto;
import com.example.demo.admin.pojo.Dept;
import com.example.demo.admin.vo.DepartmentVO;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeptMapper {

    @Select("select id,name from dept")
    List<DepartmentVO> getDepartments();

    Page<Dept> getAllDept(SearchDto searchDto);

    @Delete("delete from dept where id=#{id};")
    void deleteDeptById(Long id);


    @Insert("insert into dept(name, create_time, update_time) values (#{name},#{createTime},#{updateTime})")
    void addDept(Dept dept);
    @Update("update dept set name = #{name},update_time =#{updateTime} where id =#{id}")
    void editDept(Dept dept);
}
